At 3:30 PM -0800 11/21/07, Selena Deckelmann wrote:
>Hello,
>
>I have been looking into getting some woman-sized PostgreSQL shirts,
>in addition to the more typical men-sized tshirts. The particular
>style is American Apparel shirts, style # 2102. They are "normal
>looking" t-shirts, just proportioned a bit more correctly for a
>woman's body. The shirt says 'PostgreSQL' in small print on the front,
>and has the big elephant logo on the back. We'll most likely ask for a
>$20 donation to the PostgreSQL non-profit for each shirt.
>
>So, I'm conducting a small poll:
>
>If you are interested in a woman-sized shirt, please EMAIL ME DIRECTLY
>with a quantity, and size (XS, S, M, L, XL). If you would not wear a
>PostgreSQL woman-sized shirt yourself, please consider whether you
>would maybe get one as a gift for someone else this holiday season :)
In answer to your query, I believe the following SQL would do it:
Select count(*), size from postgresqlusers
where gender = 'female' or hasFemaleAcquaintance group by size;
If this doesn't work, what version are you using?
Oh....you're running a POLL! Never mind.
-Owen